UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lre27WsalEHN0j2bjiZXX0UPtdFBeGVxuVEecWrGZ1I='
WHERE
key_id = 'bd1352c3a36baa6c1d11149d904341fb7dda664dbf0ab0af25338cf3aa05def5'
AND (
token = 'lre27WsalEHN0j2bjiZXX0UPtdFBeGVxuVEecWrGZ1I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)