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