UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xRorUOPMelvidnotxnhi/HONaYtn+I47cJkzznVqNwY='
WHERE
key_id = '2a807b07065d6bb9a6dbd7da14f45135b7e961a95525f875956f13d267ca451a'
AND (
token = 'xRorUOPMelvidnotxnhi/HONaYtn+I47cJkzznVqNwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)