UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dGT8tIorut+Af1RKPWI+5d4Bwc1LHft1xlqwHpRlZnc='
WHERE
key_id = '505b891212a909194246d7b4bdd117339f9a2651a1983566a2fd0e35a3f430d1'
AND (
token = 'dGT8tIorut+Af1RKPWI+5d4Bwc1LHft1xlqwHpRlZnc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)