UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3lYtFfS0PGC0K8/K2YrkF9kGKz6n7iFL8BZZu1jhYss='
WHERE
key_id = '823913d3556a8cde609a586af947adb884c2b4a1d63938be3192d39a8ad3b5cf'
AND (
token = '3lYtFfS0PGC0K8/K2YrkF9kGKz6n7iFL8BZZu1jhYss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)