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