UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xN8vJffhmC1pxsY7MoLBPrh0ccERW0AtAjst7xtKcTg='
WHERE
key_id = '603a2cf91ed426982bb18eabff023ad8593a55c2704a52024c1ea2c9bc13ff68'
AND (
token = 'xN8vJffhmC1pxsY7MoLBPrh0ccERW0AtAjst7xtKcTg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)