UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A2I0BEDU2CEAiUgLK3+mPZIYa6XkE2sj/nFDsAhg2Ic='
WHERE
key_id = '7f7efb8870cacaa0218b7edbd8c1911bc94dae1754b30e486a90af6ae364131a'
AND (
token = 'A2I0BEDU2CEAiUgLK3+mPZIYa6XkE2sj/nFDsAhg2Ic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)