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