UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v2nk+6xQV/ijAzAnp9O84ZEKMbqcQPVvHDKRws4sCIA='
WHERE
key_id = '1e6f3c9d2d751836f90d92958dea7248ea8b257d8250fcc0881b83c6c4fce3d6'
AND (
token = 'v2nk+6xQV/ijAzAnp9O84ZEKMbqcQPVvHDKRws4sCIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)