UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6x8QTUGP7PQ2M40yNi+gXNqO3StBuBhCEe0g8ruH51Q='
WHERE
key_id = '686dfed2af2b50a9d00b456a90f9460ab13ca568c4d1119c06a33793262a7c9e'
AND (
token = '6x8QTUGP7PQ2M40yNi+gXNqO3StBuBhCEe0g8ruH51Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)