UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '145U57KvHr/OG9g5gO2ImFfMtDlgCdj518azk6qsWHU='
WHERE
key_id = '99054af5367009e6a75e2b4023cade0f149507b58cbc78871cf16feb9f0e971a'
AND (
token = '145U57KvHr/OG9g5gO2ImFfMtDlgCdj518azk6qsWHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)