UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fNuLIm123pMEfa2dHx4QGMnaUk6iLxdYtkjj7nKRX58='
WHERE
key_id = 'd3e692d5a01508793f1f2bb82b8d7c0ae28119a36557027a4bbc5336c2634f1e'
AND (
token = 'fNuLIm123pMEfa2dHx4QGMnaUk6iLxdYtkjj7nKRX58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)