UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QBlkRHosEF3l+XLixxef1HI7ed/hE+f184GL/nm0NDw='
WHERE
key_id = 'a7acfad69df1e812c193ee05490652a59e31479f29ace22c2eed7b22efbf7064'
AND (
token = 'QBlkRHosEF3l+XLixxef1HI7ed/hE+f184GL/nm0NDw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)