UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QIMKYPhzKChvkatbYojmtYxBGYEsesEZLcAO61LWULs='
WHERE
key_id = '7e1382afee3b8203d65b0fadc355f4e51a7316fbee958774e04ff6b7388b288f'
AND (
token = 'QIMKYPhzKChvkatbYojmtYxBGYEsesEZLcAO61LWULs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)