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