UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UGPi1/zzA+VNOi8aKXQ8ghyz/zreyX0Lmrpi46WImPM='
WHERE
key_id = '463ed1236637a2ed9b6e30316443e72bf5d37019f7e53d41413e10a6a58960b9'
AND (
token = 'UGPi1/zzA+VNOi8aKXQ8ghyz/zreyX0Lmrpi46WImPM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)