UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yb67EL+KNBvB+cMeCN1z2FsM4GEMuKXkP5TU9E9ZaxU='
WHERE
key_id = 'e8f692bf41a5a8f3fcaa8c30554cf711c8fef4272898982d5609bae95ee49288'
AND (
token = 'yb67EL+KNBvB+cMeCN1z2FsM4GEMuKXkP5TU9E9ZaxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)