UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a1ODAoNamiAJAUGrrvjH0VuNA41+eTyDw99zGMG6xM4='
WHERE
key_id = 'c394596cf8767c6ed26f627343ac2b1ea15ebb43a7c3bf630f27aa370260122d'
AND (
token = 'a1ODAoNamiAJAUGrrvjH0VuNA41+eTyDw99zGMG6xM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)