UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6pGi1VPjQk6Ozfx2ncUcV8hNyY1ahaIjboMegHuv3FY='
WHERE
key_id = '9cb3bb9f7f62f5441be89c09302df5451a69e8194847926bba7b333cfaec523a'
AND (
token = '6pGi1VPjQk6Ozfx2ncUcV8hNyY1ahaIjboMegHuv3FY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)