UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5ZBKDyb8uk8JC/gvqcmhvNAGaf31T+i1w2xX+F7HSpc='
WHERE
key_id = '5f873bd4aff6d508845823ccff415181782cae7734d88f32d9af7d074d8eea3e'
AND (
token = '5ZBKDyb8uk8JC/gvqcmhvNAGaf31T+i1w2xX+F7HSpc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)