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