UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R1x9uPNaRG6czdpNia2iJ3E2N6q27IfTt3W12vO9KME='
WHERE
key_id = '0954e732d301987e8ab4a560deb62745aeaa992097fe4a52ebedec905648331d'
AND (
token = 'R1x9uPNaRG6czdpNia2iJ3E2N6q27IfTt3W12vO9KME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)