UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NsV24lw0XD00YTgb9ZX1C5eRY70kjE4J79/PNCN4GCk='
WHERE
key_id = '29f77434e0f032ec6f3971a7a24b62d7b39e6d90f3637815b9af6c4a6aef3c16'
AND (
token = 'NsV24lw0XD00YTgb9ZX1C5eRY70kjE4J79/PNCN4GCk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)