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