UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n+ZAMhdukg8f24GuMusEI1M87QsqbnzMqBvXSbyShx4='
WHERE
key_id = 'bc51cd3537434ff4a6aec4c29a8ad2d15c95d816b5e53ca9f219ef3e33c7a6d5'
AND (
token = 'n+ZAMhdukg8f24GuMusEI1M87QsqbnzMqBvXSbyShx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)