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