UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5X0ikrd32QL4CIOivEK1IsXsimK/D5X03sFpkchvVbA='
WHERE
key_id = 'c3595127154d872afd0558e7639c7a537188927e7b5345a4d539f6ce0bdd96b5'
AND (
token = '5X0ikrd32QL4CIOivEK1IsXsimK/D5X03sFpkchvVbA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)