UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4qtDWgph0MGgzNx9qaPBlVh0I8n6tAbbbGYLPLTOY8U='
WHERE
key_id = '157778acc907cea39a72ed1ae19426ee01d3f9ded2e36a892e9365a130ef0dc7'
AND (
token = '4qtDWgph0MGgzNx9qaPBlVh0I8n6tAbbbGYLPLTOY8U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)