UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bCLVgV6FwWvWt0UCDTvJudHPG9Tf5b5YdbWf1luuwbg='
WHERE
key_id = 'e75e29cb75262abf01d7969d36df051dace7facb12070ffd0fb24fe07ba6d5d8'
AND (
token = 'bCLVgV6FwWvWt0UCDTvJudHPG9Tf5b5YdbWf1luuwbg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)