UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B98gQ343byAcQgWRODZTVeJv5amA17pplQ8Trz5t1TE='
WHERE
key_id = '505e15dc5fd8d75d2ae1245072ca4738a9af5252032211e45bf3643ad22a482b'
AND (
token = 'B98gQ343byAcQgWRODZTVeJv5amA17pplQ8Trz5t1TE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)