UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e3SW9VfGchvl7So1i4GJE/efyBaUfpxfbRQdByX9T3I='
WHERE
key_id = 'caef13fcf236311e1cb66feb9131aa6d997877782b09233151e00088cb8cf841'
AND (
token = 'e3SW9VfGchvl7So1i4GJE/efyBaUfpxfbRQdByX9T3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)