UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TOjrlzKKz2gPjtNvcHl148u60g347bRbcuoHw+NG3UM='
WHERE
key_id = '12e6bc3f1de5fddca66757d2e883c24d493e75a8190286e7ec29ab25130bdde9'
AND (
token = 'TOjrlzKKz2gPjtNvcHl148u60g347bRbcuoHw+NG3UM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)