UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TsGeaYiXEk9F3/Rdu1O4nwdAE4vQdWH54Hl9thY7v3o='
WHERE
key_id = '5ef0d01146ce71e7a69f2fb474d9cde9944e06d26691cb5bc866de44a7334613'
AND (
token = 'TsGeaYiXEk9F3/Rdu1O4nwdAE4vQdWH54Hl9thY7v3o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)